CREATE PROCEDURE sp_InsertPhieuGiao
	@Ma_PG nchar(3),
	@Ma_PD nchar(3),
	@NV_Giao nchar(3),
	@NgayGiao datetime,
	@ThanhTien  float,
	@TinhTrang  int,
	@GhiChu nvarchar(100)
AS
BEGIN
BEGIN TRAN
	INSERT INTO PhieuGiao   VALUES(@Ma_PG,@Ma_PD,@NV_Giao,@NgayGiao,@ThanhTien,@TinhTrang,@GhiChu)
	WAITFOR DELAY '00:00:08'
	ROLLBACK
COMMIT TRAN
END
GO

--EXEC sp_InsertPhieuGiao '015','005','005','2013-05-09 00:00:00.000',236000,1,N''



